﻿/*
Post-Deployment Script Template							
--------------------------------------------------------------------------------------
 This file contains SQL statements that will be appended to the build script.		
 Use SQLCMD syntax to include a file in the post-deployment script.			
 Example:      :r .\myfile.sql								
 Use SQLCMD syntax to reference a variable in the post-deployment script.		
 Example:      :setvar TableName MyTable							
               SELECT * FROM [$(TableName)]					
--------------------------------------------------------------------------------------
*/

INSERT INTO dbo.Unit VALUES('oz'), ('gallon'), ('set'), ('color'), ('gram'), ('kit'), ('none')

INSERT INTO dbo.UpcNote VALUES('NW', 'New package'), ('OP', 'Old package'), ('NE', 'Non English')

INSERT INTO dbo.Configuration 
VALUES
(
	'CompanyInfo', 
	'Park Ave of NYS Inc.	
100 Charlotte Ave Hicksville, NY 11801
Tel: (516) 939-9300 • Fax (516) 939-9302
Email: parkaveofnys1@gmail.com'
)

INSERT INTO dbo.Client
VALUES
( 'Lush Essence', '100 Charlotte Ave', 'Hicksville', 'NY', '11801', 'USA', '100 Charlotte Ave', 'Hicksville', 'NY', '11801', 'USA', 'lushessence@gmail.com', 'ILYA', '516-939-9301', NULL)

--IF NOT EXISTS (SELECT * FROM sys.server_principals WHERE name = N'lpprogram')
--CREATE LOGIN lpprogram WITH PASSWORD = 'lp123', DEFAULT_DATABASE = Warehouse, CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
--GO
--USE Warehouse
--GO
--IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = N'lpprogram')
--BEGIN
--	CREATE USER lpprogram FOR LOGIN lpprogram WITH DEFAULT_SCHEMA = dbo
--	EXEC sp_addrolemember N'db_owner', N'lpprogram'
--END
GO

